Re: Question on libpq parameters - Mailing list pgsql-general

From Owen Hartnett
Subject Re: Question on libpq parameters
Date
Msg-id p06240807c557cc58fe1a@[192.168.0.107]
Whole thread Raw
In response to Re: Question on libpq parameters  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Question on libpq parameters
List pgsql-general
At 11:45 PM -0500 11/29/08, Tom Lane wrote:
>Owen Hartnett <owen@clipboardinc.com> writes:
>>  The following libpq code chokes on me with invalid input to an
>>  integer parameter (state == PGRES_FATAL_ERR aPtr == "Error: Invalid
>>  Input syntax for integer """ .   It fails on the call to
>>  PQexecPrepared.  I suspect I'm not doing the parameters right.  Can
>>  anyone spot anything wrong?
>
>You can't just point to integers as if they were strings.  Didn't
>your compiler complain about that?
>
>            regards, tom lane

Yes, it did.  I'm confused.  My first parameter is a string, but the
following two are integers.  I thought the paramType parameter
indicated the type.  Do the integers need to be sprintf'd to strings?
There's only one paramValues array and it's type is a const char *
array.

-Owen

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question on libpq parameters
Next
From: "சிவகுமார் மா"
Date:
Subject: Query too slow with "not in" condition